You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
LAMBIS CHIRAGRA |
140.00 | |
BABELOMUREX GEMMATUS |
25.00 | |
MONETARIA ANNULUS |
3.00 | |
SPONDYLUS SWINNENI |
25.00 | |
AMPELITA DENISI |
8.00 | |
PARATROPHON QUOYI |
12.00 | |
CONUS RADIATUS |
6.00 | |
NASSARIUS DORSATUS |
6.00 | |
PUGILINA MORIO |
30.00 | |
CHICOREUS RAMOSUS |
12.00 | |
LUNULICARDIA HEMICARDIUM |
5.00 | |
MAURITIA MAURITIANA |
12.00 | |
MONETARIA MONETA |
8.00 | |
CONUS SUFFUSUS |
12.00 | |
BLASICRURA GOODALLII |
25.00 | |
CHICOREUS RAMOSUS |
12.00 | |
TUTUFA TENUIGRANOSA |
20.00 | |
BABELOMUREX GEMMATUS |
20.00 | |
XENOPHORA MEKRANENSIS KONOI |
30.00 | |
PRIMOVULA TRAILLII |
6.00 | |
MIMACHLAMYS ALBOLINEATA |
12.00 | |
PALMADUSTA LUTEA |
6.00 | |
LEIOCITHARA BUTONENSIS |
12.00 | |
CONUS RADIATUS |
25.00 | |
SYCOSTOMA BULBIFORME |
8.00 | |
LAEVICARDIUM CLARIONENSE |
8.00 | |
LOPHIOTOMA BREVICAUDATA |
12.00 | |
PLACUNA QUADRANGULA |
20.00 | |
PALMADUSTA LUTEA |
8.00 | |
CONUS RADIATUS |
6.00 | |
CONUS AMMIRALIS |
6.00 | |
MODULUS MODULUS |
4.00 | |
Total: | 544.00 |